﻿using System.Collections.Generic;
using System.Data;
using BIS.Portal.Modules.CMS.Entity;
using BIS.Utility.DAL;
using BIS.Utility.DAL.DataMapper;

namespace BIS.Portal.Modules.CMS.DAL
{
    public class ClientCmsArticleSpecicalDisplayAnDisplayDAL
    {
        /// <summary>
        /// Gets display_type_name from Special Display and Display type
        /// </summary>
        /// <returns></returns>
        public static IList<ClientCmsArticleSpecicalDisplayAnDisplayEnity> GetDisplayTypeName()
        {
            IList<ClientCmsArticleSpecicalDisplayAnDisplayEnity> list;
           
            using (IDataReader reader = SqlHelper.ExecuteReader(DALConnection.ConnectionString,
                                        CommandType.StoredProcedure,
                                        "BIS_sCMS_ARTICLE_DISPLAY_TYPE_SelectDispName"))
            {
                list = EntityMapper.FillCollection<ClientCmsArticleSpecicalDisplayAnDisplayEnity>(reader);
            }

            return list;
        }
      
      }
}
